/****** Object:  ForeignKey [FK_UserGroupRoles_Roles]    Script Date: 07/11/2011 15:25:52 ******/
ALTER TABLE [dbo].[UserGroupRoles]  WITH CHECK ADD  CONSTRAINT [FK_UserGroupRoles_Roles] FOREIGN KEY([RoleId])
REFERENCES [dbo].[Roles] ([RoleId])
GO
ALTER TABLE [dbo].[UserGroupRoles] CHECK CONSTRAINT [FK_UserGroupRoles_Roles]
GO
/****** Object:  ForeignKey [FK_UserGroupRoles_UserGroups]    Script Date: 07/11/2011 15:25:52 ******/
ALTER TABLE [dbo].[UserGroupRoles]  WITH CHECK ADD  CONSTRAINT [FK_UserGroupRoles_UserGroups] FOREIGN KEY([UserGroupId])
REFERENCES [dbo].[UserGroups] ([UserGroupId])
GO
ALTER TABLE [dbo].[UserGroupRoles] CHECK CONSTRAINT [FK_UserGroupRoles_UserGroups]
GO
/****** Object:  ForeignKey [FK_Users_UserGroups]    Script Date: 07/11/2011 15:25:52 ******/
ALTER TABLE [dbo].[Users]  WITH CHECK ADD  CONSTRAINT [FK_Users_UserGroups] FOREIGN KEY([UserGroupId])
REFERENCES [dbo].[UserGroups] ([UserGroupId])
GO
ALTER TABLE [dbo].[Users] CHECK CONSTRAINT [FK_Users_UserGroups]
GO 